(function($) {
/*
 * Function: fnGetColumnData
 * Purpose:  Return an array of table values from a particular column.
 * Returns:  array string: 1d data array
 * Inputs:   object:oSettings - dataTable settings object. This is always the last argument past to the function
 *           int:iColumn - the id of the column to extract the data from
 *           bool:bUnique - optional - if set to false duplicated values are not filtered out
 *           bool:bFiltered - optional - if set to false all the table data is used (not only the filtered)
 *           bool:bIgnoreEmpty - optional - if set to false empty values are not filtered from the result array
 * Author:   Benedikt Forchhammer <b.forchhammer /AT\ mind2.de>
 */

 $.fn.dataTableExt.oApi.fnGetColumnData = function ( oSettings, iColumn, bUnique, bFiltered, bIgnoreEmpty ) {
    // check that we have a column id
    if ( typeof iColumn == "undefined" ) return new Array();
     
    // by default we only want unique data
    if ( typeof bUnique == "undefined" ) bUnique = true;
     
    // by default we do want to only look at filtered data
    if ( typeof bFiltered == "undefined" ) bFiltered = true;
     
    // by default we do not want to include empty values
    if ( typeof bIgnoreEmpty == "undefined" ) bIgnoreEmpty = true;
     
    // list of rows which we're going to loop through
    var aiRows;
     
    // use only filtered rows
    if (bFiltered == true) aiRows = oSettings.aiDisplay;
    // use all rows
    else aiRows = oSettings.aiDisplayMaster; // all row numbers
 
    // set up data array   
    var asResultData = new Array();
     
    for (var i=0,c=aiRows.length; i<c; i++) {
        iRow = aiRows[i];
        var aData = this.fnGetData(iRow);
        var sValue = aData[iColumn];
         
        // ignore empty values?
        if (bIgnoreEmpty == true && sValue.length == 0) continue;
 
        // ignore unique values?
        else if (bUnique == true && jQuery.inArray(sValue, asResultData) > -1) continue;
         
        // else push the value onto the result data array
        else asResultData.push(sValue);
    }
     
    return asResultData;
}}(jQuery));
 
 
function fnCreateSelect( aData )
{
    var r='filter : <select><option value=""></option>', i, iLen=aData.length;
    for ( i=0 ; i<iLen ; i++ )
    {
        r += '<option value="'+aData[i]+'">'+aData[i]+'</option>';
    }
    return r+'</select>';
}

 
$(document).ready(function() {
    /* Initialise the DataTable */
    var oTable = $('#mygrid').dataTable( {
	    "bJQueryUI": true,
        "sPaginationType": "full_numbers" ,
        "oLanguage": {
            "sSearch": "Search all columns:"
        }, 
		"aoColumns" : [
			/*{"bVisible" : false},
			{"bVisible" : false},
			{"bVisible" : false},*/
			{ "sTitle": "Id",   "mData": "id" , "bVisible" : false},
			{ "sTitle": "sekCode",   "mData": "sekCode" , "bVisible" : false },
			{ "sTitle": "stockCode",   "mData": "stockCode" , "bVisible" : false },
			{ "sTitle": "Sekuritas",   "mData": "Sekuritas" },
			{ "sTitle": "Stock",   "mData": "Stock" },
			{ "sTitle": "BuyingPrice",   "mData": "BuyingPrice" },
			{ "sTitle": "TodayPrice",   "mData": "TodayPrice" },
			{ "sTitle": "Avg.Price",   "mData": "Avg.Price" },
			{ "sTitle": "CutLoss",   "mData": "CutLoss" }					
		]
    } );
	
    /* Add a select menu for each TH element in the table footer */
    $(".selectMe ").each( function ( i ) {
        this.innerHTML = fnCreateSelect( oTable.fnGetColumnData(i+3) );
        $('select', this).change( function () {
            oTable.fnFilter( $(this).val(), i+3 );
        } );
    } );     
	
	
	 $('td.updateable', oTable.fnGetNodes()).editable( 'admin_dailytrans/updatePrice', {
		 "callback": function( sValue, y ) {
			var aPos = oTable.fnGetPosition( this );
			oTable.fnUpdate( sValue,  aPos[1],1 );
		},
		"submitdata": function ( value, settings ) {
			return {
				"row_id": this.parentNode.getAttribute('id'),
				"id":this.parentNode.getAttribute('sekCode'),
				"column": oTable.fnGetPosition( this )[2]
			};
		}
	 } );
	 
	$( "#dateForMe" ).datepicker({
		changeMonth: true,
		changeYear: true,
		dateFormat: 'yyyy-mm-dd',
		closeText: 'X'            
	});
	
	$("#dateForMe").change(function() {
		$( "#dateForMe" ).focus();
	});

} );